package com.jinzhi.jzweb.dao;

import com.jinzhi.common.base.BaseDao;
import com.jinzhi.jzweb.domain.ExaminationAnswerSheetComDO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 
 * <pre>
 * 考试答卷
 * </pre>
 * <small> 2020-02-24 21:00:12 | lance</small>
 */
public interface ExaminationAnswerSheetComDao extends BaseDao<ExaminationAnswerSheetComDO> {


	@Select("SELECT jeas.id ,jeas.epaper_id as epaperId , jeas.stu_sign_id as stuSignId , jeas.answer_list as answerList \n" +
			"FROM jz_stu_sign_up_com as stu  \n" +
			"left join jz_certificate_news as jon on stu.org_id = jon.id  \n" +
			"left join jz_examination_answer_sheet_com as jeas on stu.id = jeas.stu_sign_id  \n" +
			"where  jeas.id is not NULL")
	List<ExaminationAnswerSheetComDO> findList (Long orgId);

}
